﻿
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[sproc_CM_UpdateContact]') AND type in (N'P', N'PC'))
    DROP PROCEDURE [dbo].[sproc_CM_UpdateContact];
GO
CREATE PROCEDURE [dbo].[sproc_CM_UpdateContact]
@ID INT,
@clientid int,
@MarketmanID int,
@UpdateTime datetime,
@ContactTime datetime,
@CurStatus nvarchar(100),
@ContactAim nvarchar(500),
@SellMoney int,
@BargainPrognosis nvarchar(50),
@ContactType nvarchar(50),
@Fee int,
@FeeUsed nvarchar(100),
@ContactContent nvarchar(1000),
@NextContactAim nvarchar(1000),
@NextContactTime datetime

AS

    UPDATE UDS_CM_ClientContact SET
    clientid=@clientid,
    marketmanid=@marketmanid,
    updatetime=@updatetime,
    ContactTime=@ContactTime,
    curstatus=@curstatus,
    ContactAim=@ContactAim,
    SellMoney=@SellMoney,
    BargainPrognosis=@BargainPrognosis,
    ContactType=@ContactType,
    Fee=@Fee,
    FeeUsed=@FeeUsed,
    ContactContent=@ContactContent,
    NextContactAim=@NextContactAim,
    NextContactTime=@NextContactTime
    WHERE ID=@ID